﻿CREATE TABLE [dbo].[GeneralExpressWaybillInfo] (
    [CodeNum]        VARCHAR (32) NOT NULL,
    [CodeStatus]     TINYINT      NULL,
    [CreateTime]     DATETIME     NULL,
    [CreateManageID] INT          NULL,
    [CodeType]       INT          NOT NULL,
    [BuyUserID]      BIGINT       NULL,
    [BuyTime]        DATETIME     NULL,
    [OrderID]        VARCHAR (32) NULL,
    [UseTime]        DATETIME     NULL,
    CONSTRAINT [PK_GENERALEXPRESSWAYBILLINFO] PRIMARY KEY NONCLUSTERED ([CodeNum] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'使用时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'GeneralExpressWaybillInfo', @level2type = N'COLUMN', @level2name = N'UseTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'订单标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'GeneralExpressWaybillInfo', @level2type = N'COLUMN', @level2name = N'OrderID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'购买时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'GeneralExpressWaybillInfo', @level2type = N'COLUMN', @level2name = N'BuyTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'购买用户标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'GeneralExpressWaybillInfo', @level2type = N'COLUMN', @level2name = N'BuyUserID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'单号种类', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'GeneralExpressWaybillInfo', @level2type = N'COLUMN', @level2name = N'CodeType';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'导入管理员标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'GeneralExpressWaybillInfo', @level2type = N'COLUMN', @level2name = N'CreateManageID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'导入时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'GeneralExpressWaybillInfo', @level2type = N'COLUMN', @level2name = N'CreateTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'单号状态', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'GeneralExpressWaybillInfo', @level2type = N'COLUMN', @level2name = N'CodeStatus';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'单号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'GeneralExpressWaybillInfo', @level2type = N'COLUMN', @level2name = N'CodeNum';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'一般快递单号信息', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'GeneralExpressWaybillInfo';

